The Sparks Foundation (GRIPDEC20 DSBA Task2)

Task Objective: Exploratory data analysis on 'Global Terrorism' Dataset

Author : Mrunal Battise

Importing Required Libraries

Loading Dataset

Data Cleaning

Data is Ready to Analyse

1.Analysing Terrorism in India

India faced around 12000 Terrorist attacks since 1972

In India Terrorist Attacks started increasing from 2008 exponentionaly

There is no record of Terrorist Activity in 1993

Highest Casualties recored in window of 1988-1992 and 2005-2009 (more than 1500 Peoples every year)

2008 and 2006 has highest Casualties since 1972 resp.

If observe the plot we can say even window of 1995 to 2007 has less attacks than window of 2008 to 2016 it recorded higher no. of casualties !!!

May be because India retaliating the attacks quickly

Even the data says that 43% attacks in India are done by Unknown Groups they are indirectly connected to Major Active Groups like Maoists,ULFA, Hizbul Mujhhideen and Lashkar-e-Taiba o

or we can say India Intelligence not found the main operators of 43% Attacks

Some Probable Insights-

Sikh Extrimists had 4th Highest No. of Attacks though cause 2nd Highest No. of Kills

Naxalites is not among the 15 Most Active Terrorist Group but caused 10th highest No. of Kill

Maoists responsible for 19% attack in India(higest after unknown groups) but caused only death of 790 peoples(5th Highest).

Sikh Extrimists and CPI-Maoist are only groups in top 10 who caused more Kills than Wounded

Surprizing!! around 15k Casualties caused by Unknown Groups

Strange!! 624 time Cities in Dataset are Unknown, data should be updated

Shrinagar is worstly affacted compared to other 658 attacks in 44 Years i.e. around 15 Attacks per Year.

If we observe most of cities are in North and North-East Part of India we can say this regions are highly affacted by terrorism.

Mumbai is Not amoung 20 most attacked city in India but has 3rd Highest No. of Casualties

Similarly Hydrabad , Chennai and Ahemdabad is also not in list but 9th,14th and 17th highest No. of Casualties

Mumbai, Dantewada ,Ahemdabad, Hyderabad, Chennai are only Central and Southern Cities in List.

Above animation gives quick overview of Attack Locations on Map, City under attack,No. of Casualties, No. of People Killed from 1972 to 2016 in World.

Above animation gives quick overview of Attack Locations on Map, City under attack,No. of Casualties, No. of People Killed from 1972 to 2016 in India.

1.1 Analysing Terrorism in Mumbai

Mumbai were 28 times targeted by Terrorists out of which 7 the most done in year 2008 alone.

Operators behind 10 Attacks in Mumbai were Unknown.

In Mumbai most Casualties caused by Lashkar-e-Taiba and its attributions like Deccan Mujahideen

Lashkar-e-Taiba operated single Attack in Mumbai but caused highest Casualties(1005 peoples) out of which 188 were killed and 817 wounded.

Civilians at Hotels and Stations are highly trageted by terrorists every time.

Deccan Mujahideen is only terrorist group who targeted Kids in Mumbai.

Unfortunetly Around 90% of Terrorist Attacks in Mumbai were successful.

Like Mumbai one can analyise City of thier Interest

2.Analysing Terrrorism in World

2.1 Most ..... in the World.

Top 4 Most Attacked Countries are in Asia and Total 10 i.e 50% Asian Contries in 20 most attacked countries

and agian most of them are in Middle East.

3 each in South America, Europe and Africa and only one U.S. in North America

Few Countries like Syria and last four are not in List of 20 most Attacked Countries but they in 20 most affacted Countries in World i.e. faced more Casualties.

Bang!! Bangdad the Capital of MOst Attacked Country Iraq alone records around 22k Kills i.e. combined equal to next 5 cities in list.

2.2 Aanlysing Regions

Central Asia, East Asia and Australasia are few least affacted Regions.

While Middle East & North Africa and South Asia records around 5.6 Lakhs Casualties and 2.47 Lakhs Kills

Around 52% of Total Terrorist Attacks happend in only two Regions- 1.Middle East & North Africa and 2.South Asia

2.3 Analysing Attack Type-Subtype, Target-Sub Target and Weapon Type-Subtype.

Bombng and Explosions Killed around 1.57 Lakhs peoples and wounded 3.72 lakhs peoples !!

Private Citizens are drasticaly affacted by Terrorism.

Business, Govt. and Transportation also affacted highly after Military the second most affacted.

Military Bodies and Police are highly targeted by Terrorists after cilvilians.

Around 82k Terrorists Attacks were done by Unknown Groups or Intelligence Agencies were failed to find the operators

Most of Terrorist Groups above are from Middle East and South Asia.

Around 31K Casualties in World are casued by Unknown Terrorist Groups

ISIL operated less attacks than Taliban(Highest Attack Operator Group in Wolrd) but caused more Kills - around 60K.

Explosives are most used weapons by Terrorist after Firearms and Incendiary

Analysing extra parametes like Property Damage, Host Kids,Days of Attacks,Months etc.

Kids are more targeted in Middle East and North Africa

Average Days for which Terrorist Attacks was active is almost 15 days.

Only 891 Attacks were controlled in single day.

Most Attacks Taken place in 5th i.e. May and least in February.

3. Extra PLots

Bombing/Explosion is most used Attack Type by Terrorists in all regions.

Central America is only Region where Armed Assault(2nd Most Used Attacks Type) more used than Explosions.

From 1979 to 1997 Regions like South America, Central America and Caribbean and Western Europe are highly affacted.

2012!! was the 1st year in history when total Terrorist Attacks in World crossed mark of 8000.

2014 registered highest attacks around 17000 snice 1972.

Some Insight-

Austalasia and Oceania is least affacted Region by Terrorism.

Terrorist attacks start incresing fastly from 2003-4 in regions like Middle East & North Africa and South Asia.

same Pattern can be observed for Regions Southeast Asia and Sub-Saharan Africa from 2006.

Animation 2.0

Above animation gives quick overview of Attack Locations on Map, City under attack,No. of Casualties, No. of People Killed from 1972 to 2016 in World.

Above animation shows No. of Casualties, NO. of People Killed, No. of People Wounded in different Regions of world from 1972 to 1973.

Thanks and Happy Learning